Aggregation Descriptives

Geographic county level

Map of counties included in final outputs

The map below shows which counties are a part of the county-total aggregation, the county-month aggregation, or both.

Number and % of counties included in the final output, by state

The table below presents county coverage by state. The tabs above the table can be toggled to view data for each dataset.

Counties with high share of missing addresses

Payment records may be locatable to a county even if its street address is missing (for example, if an ERA grantee’s jurisdiction is entirely within a single county).

In deriving the number of unique assisted addresses for the aggregation, we treat records with missing addresses as unique from every other address. However, this assumption is liberal because multiple payments to a single address cannot be distinguished from single payments to multiple addresses if the address is missing.

Therefore, if a county includes a large proportion of records with missing addresses, the number of unique assisted addresses may be inflated. The table below presents these data. For example, nearly 100% of records located to Washington, D.C. are missing street address.

Grantee level

The tables below present information relating to data coverage and quality. These data are presented at the grantee level, rather than at the geographic county level, because data thresholding decisions were made at the grantee level.

Number of grantees included, by type

Number of grantees included, by state and type

Grantees included with less than 90% variable quality

This table shows grantees included in the aggregations where less than 90% of their records (for either ERA1 or ERA2) met all of the following criteria:

  • Record within the geographic jurisdiction of the grantee
  • Record locatable to a specific county
  • Positive payment amount recorded, below 99.9th percentile value of all records
  • (For county-month dataset only) Date of payment recorded, neither too early nor too late for the program

Please see the Methods page for more details on the thresholding process.

Grantees included with low spending amounts

This table shows grantees included in the aggregations where the grantee’s summed positive payments in the ERA1 file was less than 80% of their final allocation for ERA1, or where their summed positive payments in the ERA2 file was less than 50% of their final allocation for ERA2.

These grantees may not have fully reported their assistance spending, especially for ERA2.

Back to top